UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BCXKp3EsJUmTPckBUbPkUAKMMcp8pJiVIdWtV+37axM='
WHERE
key_id = 'a48a639ed666080753cbb62a9d6178485750e389a264c36913a581b9add07eac'
AND (
token = 'BCXKp3EsJUmTPckBUbPkUAKMMcp8pJiVIdWtV+37axM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)