UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8wWPzoCEn3mticbRDSAN3ZiUh1JYeEac0gaJOkmRelo='
WHERE
key_id = 'f229ab1f63703162ab3f5204dfabe1671bd9f77db8e77e163efba6d16a432007'
AND (
token = '8wWPzoCEn3mticbRDSAN3ZiUh1JYeEac0gaJOkmRelo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)