UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWT7Ee4TsvvE3IYI+fbBRj+hMXSDBj6CNOOYA7My9uE='
WHERE
key_id = 'f7d91ba01f57a23367e63d925dddb568301741f81d2f9ff45385c54b14aa35d8'
AND (
token = 'XWT7Ee4TsvvE3IYI+fbBRj+hMXSDBj6CNOOYA7My9uE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)