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