UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MGFR9gMkyJ9zhBDkjyMbgL9GFTvqyQ7vG6QQRd5kK/w='
WHERE
key_id = 'd520637cd55b16aba37813ad02f33c8aed7aee6b591e06e794cfa74e134b7cbc'
AND (
token = 'MGFR9gMkyJ9zhBDkjyMbgL9GFTvqyQ7vG6QQRd5kK/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)