UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/B7ZXggd2FaNmdHpdyxb4uka62ALb7C2VU84Uf5mS+o='
WHERE
key_id = 'c8b7a129f1de727c53c693965a13488d39d356a45e7f221ee952ca8ee514719d'
AND (
token = '/B7ZXggd2FaNmdHpdyxb4uka62ALb7C2VU84Uf5mS+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)