UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZsGIhjEQs+j3S4wuFxz8kU5ckyzHf5KWXqin4nndTuQ='
WHERE
key_id = 'a2bb540200c074be7c215cd6ae7cc44413eea256e1c94c49cb14288881613cbc'
AND (
token = 'ZsGIhjEQs+j3S4wuFxz8kU5ckyzHf5KWXqin4nndTuQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)