UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2o4P1nNBPJSnAphX0KYSwwuA29x+tMMZeUSZS+69+24='
WHERE
key_id = 'a3c98b4766981aa35f17fc5d9ccb27f271bb9a6220e24925d3a3554567d0682c'
AND (
token = '2o4P1nNBPJSnAphX0KYSwwuA29x+tMMZeUSZS+69+24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)