UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gp4cadnAReWCJFylzjCBppuFT8avXaMYazmlfUsqY2A='
WHERE
key_id = '309fe6adf19fcd5bd40ba4b02e30c62d4df27f253dadc3b2f74daee15cc7efbe'
AND (
token = 'Gp4cadnAReWCJFylzjCBppuFT8avXaMYazmlfUsqY2A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)