UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UIaLPLIlfj1hIfu7zaVn1qH0fOVEK7B5i5apqOT0iMg='
WHERE
key_id = 'c2a20cba15b3e4e1f6dd219d21ee14ae60e02d19b34f4303db04b7aa95142bfc'
AND (
token = 'UIaLPLIlfj1hIfu7zaVn1qH0fOVEK7B5i5apqOT0iMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)