UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LGzkEtK58i8jBs9wdc/55AmDu789F/dYXiySY4I3L+Y='
WHERE
key_id = 'b85fc6a1da49f04e89f53c1ff511e8c37b23fd28581fe274eb027721fac651fa'
AND (
token = 'LGzkEtK58i8jBs9wdc/55AmDu789F/dYXiySY4I3L+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)