UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZjTPpUzllGOPZECnhcVFIbRzQvjKArvO1VXIL+Q5Y4='
WHERE
key_id = '56e6ac5f947dfd4a08674b5c025892ffa4d8891454d66ed22e899924319f5904'
AND (
token = 'zZjTPpUzllGOPZECnhcVFIbRzQvjKArvO1VXIL+Q5Y4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)