UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UGzhKRzOteD7LQjVbpjkOp4R0XUZwjAx1Loat0y+/ak='
WHERE
key_id = '56f7a9db994d004b697cdc6f9bd8b1f2a0a5cc9c15aba9c3fd8f9ddf68fafdc8'
AND (
token = 'UGzhKRzOteD7LQjVbpjkOp4R0XUZwjAx1Loat0y+/ak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)