UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XMlNRQscR8QB8Lgk8wBQ6ECAo6pC96ROwxBihoIAom0='
WHERE
key_id = 'bcb6bd7574120094861cdac253b69e7db4a2ffac9765cc1cb1e23c73e07b412f'
AND (
token = 'XMlNRQscR8QB8Lgk8wBQ6ECAo6pC96ROwxBihoIAom0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)