UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wdG11qffTIR3Vdr8ekOfF5A56z3S21+SwyjtW4+9DF0='
WHERE
key_id = '8bcc0c162b06b46c69f2de03ded33d86818506f5713c281d0d246e74658cea82'
AND (
token = 'wdG11qffTIR3Vdr8ekOfF5A56z3S21+SwyjtW4+9DF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)