UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I9ZU35XN7gP3Tu2aGCOdEcl/3VioCdfDIot+f5IfDRA='
WHERE
key_id = '9f0c9d738a7f67fefcf9a62ee37a845acee012125c79fe59ecdc693e469e14ae'
AND (
token = 'I9ZU35XN7gP3Tu2aGCOdEcl/3VioCdfDIot+f5IfDRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)