UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TN8FT2ItZVtL7zdAjEbVNHzpbm8U9BlQmns3mmPdPEE='
WHERE
key_id = '8172b5a69bf2f566e8487d227ac6f2225f9f4658d9cb3ac3e94cb4c07c9c64f1'
AND (
token = 'TN8FT2ItZVtL7zdAjEbVNHzpbm8U9BlQmns3mmPdPEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)