UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGyZ5olcdUG9cTaVJJN47ih2zOnDvZ82jf3ainrrLnQ='
WHERE
key_id = '6c512e082231e7bd2664aeacd2ea0177b878ecf4a83523cba568837545cecd29'
AND (
token = 'HGyZ5olcdUG9cTaVJJN47ih2zOnDvZ82jf3ainrrLnQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)