UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ghT3+fDw7BHIOg2XfCpF0/2vwx5JmuzuNau4y200Wrc='
WHERE
key_id = '27c3da2442cbde27c48a4d33c5dd3f5eef670f9849aed4a09c4eaa4bcfdf119e'
AND (
token = 'ghT3+fDw7BHIOg2XfCpF0/2vwx5JmuzuNau4y200Wrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)