UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5nmfSDXotrBcVdi9mc4KTlIysucGJwcoKuCIkRa4zXE='
WHERE
key_id = 'cfc69f560d12edb40fff103a21fd866de1c7e017180591cb947376089aff99f3'
AND (
token = '5nmfSDXotrBcVdi9mc4KTlIysucGJwcoKuCIkRa4zXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)