UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8cmB8Rly1/FxBIy4qoVuLNuZCadmeefwDtUGD8U6X38='
WHERE
key_id = '7a23badb453c8ac625feb9dceb46cbcd69920215dcdcc7418a1e736b5816f19a'
AND (
token = '8cmB8Rly1/FxBIy4qoVuLNuZCadmeefwDtUGD8U6X38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)