UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aI/aB6L29ju1pq5odLJ3qlxoaZkVa7h+BcDD70bnpQ='
WHERE
key_id = '9567da7a01f843d0f3484066f34be59f979fac6f2dab7fa15298cdae7eac4263'
AND (
token = '7aI/aB6L29ju1pq5odLJ3qlxoaZkVa7h+BcDD70bnpQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)