UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPRvlzFjWDeW8qaEj3AdN2LnyXOe52eORDVPC7rZtL4='
WHERE
key_id = '054c829954a1d98c6f57176bc79c33385e0f35252ebf05dcadd99ad2896f62b2'
AND (
token = 'KPRvlzFjWDeW8qaEj3AdN2LnyXOe52eORDVPC7rZtL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)