UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '48OhFrZ3VYlyDvzD6bcVpxb1/ijs8zS2kT/vvr73jX0='
WHERE
key_id = '8aa31dadaf3ea7308459f33beffa4769827e1befe1381c4b01e8328bc43bb1a7'
AND (
token = '48OhFrZ3VYlyDvzD6bcVpxb1/ijs8zS2kT/vvr73jX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)