UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZzDiCD0QdS+tqss656JkOIxtIOlYwyJM5qP6GbHPEQ='
WHERE
key_id = '037f681d46ab942b3cd11f2312f7ae22fcc9fae2847aba20b0b7788197e49566'
AND (
token = 'PZzDiCD0QdS+tqss656JkOIxtIOlYwyJM5qP6GbHPEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)