UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KMAgpM7oE6Ov3iWW6LCP8ETRU5FPt3sAKLpkWC6oLjU='
WHERE
key_id = '278df92d4c94d7f09e00a5f85113bd1f9313d5a88c8a028cf9fbe041f3f16fab'
AND (
token = 'KMAgpM7oE6Ov3iWW6LCP8ETRU5FPt3sAKLpkWC6oLjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)