UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGn+xv0UaSJHOsitBa0IvWjhxeNGuIxzkBGTnklh1Uc='
WHERE
key_id = '9327a18079758182501f631085d774d365ec132cf8b68e24b73c3776bf74d2fe'
AND (
token = 'bGn+xv0UaSJHOsitBa0IvWjhxeNGuIxzkBGTnklh1Uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)