UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjpvTz71APTmWBTuBRzqLnTqw0Y028OaFB7kovi9vkI='
WHERE
key_id = 'c8f39e2e3ba210bb65e4a2e69f677dbc5f98188a778f4d70e5bf841ae8453cc7'
AND (
token = 'hjpvTz71APTmWBTuBRzqLnTqw0Y028OaFB7kovi9vkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)