UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CmrXpYGa0Nrg9Fob1ykrBBO7UgE+utyfBTYd5QG3YUg='
WHERE
key_id = 'fbee2fe56de49a0e847b86fef149813fde80fbf3ad5949bf57d29f99267a7562'
AND (
token = 'CmrXpYGa0Nrg9Fob1ykrBBO7UgE+utyfBTYd5QG3YUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)