UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7nBtNU8p9qZjqTXNW5KKHwZnpQyyB/0QaFADGrNFt4I='
WHERE
key_id = '8b32921f262ba857487b8b5881c16a350d0337c0b3004ca6f280b10fb90bb698'
AND (
token = '7nBtNU8p9qZjqTXNW5KKHwZnpQyyB/0QaFADGrNFt4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)