UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vtGYIm4ObVlzHEkWrX4Xpfl8pMavXkRbtC605P0VqRA='
WHERE
key_id = '8f35195a64bb801c6bdff9acb07a8d56633c238df800eeb026c02dee46b67d95'
AND (
token = 'vtGYIm4ObVlzHEkWrX4Xpfl8pMavXkRbtC605P0VqRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)