UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hrNa6wpuoyT1vJsTIcu5wwn6/MH7IAyCQMnc6vLsb50='
WHERE
key_id = 'cdda318b654f98112b82816956de4f6a0733a649fcdfb245fa2c064312b9860a'
AND (
token = 'hrNa6wpuoyT1vJsTIcu5wwn6/MH7IAyCQMnc6vLsb50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)