UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YWG1T07pC45icXKB2wCna/a0Kom8wtAlCiFxY5CU+x8='
WHERE
key_id = 'bc7d86017d24314a95b741a27795ae8e76dded82fa396c61dd970c55bb6e5163'
AND (
token = 'YWG1T07pC45icXKB2wCna/a0Kom8wtAlCiFxY5CU+x8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)