UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xEg5/wq7XEnbfD4hisQk0PCGLPOBM8+BqEz8pHpeIM='
WHERE
key_id = 'b174985d4260b81c4070701c540a7bbaa720bd04b23a65cc1d9b2bbb7ddc258a'
AND (
token = '8xEg5/wq7XEnbfD4hisQk0PCGLPOBM8+BqEz8pHpeIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)