UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G75sTeKnkMLX/HND1w81wtmhnPRtkjCU7u3A/Nzo+a8='
WHERE
key_id = '8d046306aef224177dfb877446552d48a019a950dcf78b92cd3ef49ff93a2ec5'
AND (
token = 'G75sTeKnkMLX/HND1w81wtmhnPRtkjCU7u3A/Nzo+a8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)