UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p0YfUZz478TTsJ/Or2djyJwdPtgX4Ox7T0sH+PZ27g4='
WHERE
key_id = '24a07f7accea46d745ea544953247207376c950afe2dbb42f15ac647ae0ff14c'
AND (
token = 'p0YfUZz478TTsJ/Or2djyJwdPtgX4Ox7T0sH+PZ27g4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)