UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BQKHPbXfjbKItCXt2hqsjcBQQ9AitRTMUaBFvuOLWmY='
WHERE
key_id = '3049369df87126cba9ea75e77701278e22b4521d289aa2d680d2510324c6ec8e'
AND (
token = 'BQKHPbXfjbKItCXt2hqsjcBQQ9AitRTMUaBFvuOLWmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)