UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HZxJ40Csd24Xs4eSBpFP7CtqkcYgYfGXaMmXzrt+r5k='
WHERE
key_id = 'bfe5a9ff2d68828ab404eb4b84a2a6c24d7b244b194edcc2e03454d4c591ce42'
AND (
token = 'HZxJ40Csd24Xs4eSBpFP7CtqkcYgYfGXaMmXzrt+r5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)